childadverseeventcomplains

Table: childadverseeventcomplains

The childadverseeventcomplains table stores complaints or observations related to a child’s adverse event.
It is used to record additional details reported during follow-up or investigation of adverse events.

---

Columns

Column Name	Data Type	Constraints	Description
childAdverseEventComplainId	int(11)	NOT NULL, AUTO_INCREMENT	Unique identifier for each complaint record
createdDate	datetime	NULL	Timestamp when the complaint record was created
lastEditedDate	datetime	NULL	Timestamp when the complaint record was last edited
childAdverseEventId	int(11)	NULL	References the associated adverse event
complain	varchar(255)	NULL	Complaint or issue reported related to the adverse event
other	varchar(255)	NULL	Additional notes or details
createdByUserId	int(11)	NULL	User who created the complaint record
lastEditedByUserId	int(11)	NULL	User who last edited the complaint record

---

Indexes

1. PRIMARY - Primary key on childAdverseEventComplainId
2. childAdverseEventId - Index on childAdverseEventId

---

Foreign Key Relations

• childAdverseEventId → childadverseevent.childAdverseEventId
  • Links the complaint to the specific adverse event

---

Usage Notes

• Stores complaints or follow-up details related to a child’s adverse event.
• other field is used for additional remarks or uncommon issues.
• Audit fields (createdByUserId, lastEditedByUserId, createdDate, lastEditedDate) maintain a history of changes.
• Ensures referential integrity with the childadverseevent table.